Course Description:
This leading edge Financial Analysis, Modeling and Forecasting course will provide you with the essential financial modeling skills for finance professionals around the world. Excel VBA - the embedded programming language in Excel allows you to create powerful spreadsheet models by overcoming the limitations of Excel and automating spreadsheet procedures. In this course, you will learn the fundamentals of Excel VBA and to apply it to developing financial models for various purposes.
By the end of this training seminar you will have learned to:
- Understand Excel VBA and its application in finance
- Design simple spreadsheet models for financial data analysis using Excel VBA
- Design and build practical and effective financial models in Excel
- Improve your skills in analysing and interpreting financial statements
- Build financial forecasting models for a range of business applications
- Apply financial modelling techniques to investment decision-making
- Use a range of tools to analyse and manage business risk
Who Should Attend?
Financial Accountants, Cost and Management Accounting Staff, Finance Managers, Planning Managers, Commercial Managers, Capital Investment and Project Team Members
Scope: Global Mode of training: Virtual Time: From 9:00am to 12:00pm
Venues and dates:
August 03-14, 2020
Sept 07-18, 2020
Nov 02-13, 2020
Related Courses
Course Name
Dates
Action
TRAINING PROGRAMS IN FINANCE, ACCOUNTING AND BUDGETING
PUBLIC SECTOR ACCOUNTING AND BUDGETING
This Public Sector Accounting and Budgeting training course has been designed to provide you with up to date knowledge and practical skills in the preparation and interpretation of public sector financial statements and budgets.
It is designed to provide a comprehensive briefing on the fundamental principles and key functions in the continuously developing sphere of public sector finance.
This training also incorporates a vital update on International Public Sector Accounting Standards Board (IPSASB) as well as recent developments in the field of New Public Management, specifically focusing on the reasons for and approaches to New Public Financial Management.
-
-
-
-
ADVANCED FINANCIAL STATEMENTS ANALYSIS
This interactive Advanced Financial Statements Analysis training course will update and develop your skills in analysing business activities through Evaluation and Interpretation of Financial Position and Performance of an entity. It will guide you through the key steps of analysing financial statements, evaluating new investments and measuring the performance of your organisation. This course will develop your ability to improve efficiency while pinpointing problem areas for remedial action. You will have the opportunity to acquire skills and technical knowledge that will enable you to manage more effectively.
-
-
-
-
ACCOUNTING POLICIES AND PROCEDURES TRAINING
Accounting and finance policies and procedures are the most efficient way to implement company-wide useful internal control tools in any organization. They are part of every business cycle: purchase and payment cycle, inventory and production, HR and payroll, fixed assets and capitalization of costs, and the sales and collection cycle. On top of that, accounting and finance policies and procedures are essential for the board of directors and senior management to communicate limitations and authorities given to different managers and employees throughout the organization. Moreover, their use is also extended to organize financial reporting and compliance with regulators outside the organization.
In this course, participants will be encouraged to think of risk-based processes to write and implement operational policies and procedures.
-
-
-
-
BUDGET PREPARATION, ALLOCATION & COST CONTROL
Budgeting, tracking, controlling and reducing cost represent essential activities to be performed and monitored by organizations as they implement their key processes, activities and operations. In addressing these issues, this Budgeting course is relevant for those professionals and analysts facing the difficult challenge of improving performance while reducing costs of those processes for which they are accountable.
-
-
-
-
ADVANCED BUDGETING & FORECASTING
Budgeting and forecasting are crucial elements for the management of contemporary organizations. If companies want to stay competitive, they are urged to link their strategies with accurate systems of resource allocation and performance measurement. Along this line, budgeting and forecasting represent essential activities to be performed by organizations as they implement their key processes, activities and operations. In addressing these issues, this course is relevant for those professionals & analysts facing the difficult challenge of improving performance while reducing costs of those processes for which there are accountable.
-
-
-
-
-
ADVANCED MICROSOFT EXCEL EXCEL IN EXCEL
This intensive hands-on training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.
MS Excel gives you the right tools for your operations no matter where you work or which department you are in. Maximize the value of your data by building great charts, using conditional formatting, identifying trends, bringing data together and utilizing online access.